﻿<%@ Page Title="Statistics" Language="C#" MasterPageFile="~/AdminPages/AdminPanel.Master" AutoEventWireup="true" CodeBehind="Statistics.aspx.cs" Inherits="MasterPageGroupF3.AdminPages.WebForm6" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<div class="content1">
        <div class="frame">
            <div class="head">

            </div>
            <div class="content-catalog">
                <div id="name-member">
                    Thống kê doanh thu
                </div>
                <div id="function">
                    <ul>
                      
                    </ul>
                
                </div>
                <div class="clear">

                </div>
            </div>
            <div class="tail">

            </div>
        </div>
        <div class="frame">
            
            <div class="head">

            </div>

            <div class="provider">
           
                    <div id="search">
                        <strong>
                            <asp:Label ID="Label2" runat="server" Text="Doanh thu theo từng đợt khuyến mãi :" 
                            style="font-size: large; font-weight: 700;"></asp:Label>&nbsp;
                        </strong>
                    </div>

                    <div id="listprovider">
                        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
                             AllowPaging="True" PageSize="5"
                             BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" 
                            CellPadding="4" ForeColor="Black" GridLines="Vertical" 
                            onpageindexchanging="GridView1_PageIndexChanging">
                            <AlternatingRowStyle BackColor="White" />
                            <Columns>
                                <asp:BoundField DataField="IDPRODUCT" HeaderText="ID" />
                                <asp:BoundField DataField="SLOGAN" HeaderText="Name" />
                                <asp:BoundField DataField="PRICE" HeaderText="Price" />
                                <asp:BoundField DataField="SO_NGUOI_MUA" HeaderText="Số người mua" />
                                <asp:BoundField DataField="DOANH_THU" HeaderText="Doanh thu" />
                            </Columns>
                            <FooterStyle BackColor="#CCCC99" />
                            <HeaderStyle BackColor="#6B696B" Font-Bold="True" ForeColor="White" />
                            <PagerStyle BackColor="#F7F7DE" ForeColor="Black" HorizontalAlign="Right" />
                            <RowStyle BackColor="#F7F7DE" />
                            <SelectedRowStyle BackColor="#CE5D5A" Font-Bold="True" ForeColor="White" />
                            <SortedAscendingCellStyle BackColor="#FBFBF2" />
                            <SortedAscendingHeaderStyle BackColor="#848384" />
                            <SortedDescendingCellStyle BackColor="#EAEAD3" />
                            <SortedDescendingHeaderStyle BackColor="#575357" />
                        </asp:GridView>


                        <br />
                        <strong>
                            <asp:Label ID="Label1" runat="server" Text="Doanh thu theo nhà cung cấp :" 
                            style="font-size: large; font-weight: 700;"></asp:Label>&nbsp;
                        </strong>
                        <asp:GridView ID="Provider" runat="server" AllowPaging="True" 
                            AllowSorting="True" PageSize="5" AutoGenerateColumns="False" CellPadding="4" 
                            ForeColor="#333333" GridLines="None" 
                            onpageindexchanging="Provider_PageIndexChanging">
                            <AlternatingRowStyle BackColor="White" />
                            <Columns>
                                <asp:BoundField DataField="IDPROVIDER" HeaderText="ID" />
                                <asp:BoundField DataField="NAME" HeaderText="Tên công ty" />
                                <asp:BoundField DataField="PHONE" HeaderText="Số điện thoại" />
                                <asp:BoundField DataField="QUANTITY" HeaderText="Tổng đơn đặt hàng" />
                                <asp:BoundField DataField="DOANHTHU" HeaderText="Doanh Thu" />
                            </Columns>
                            <EditRowStyle BackColor="#7C6F57" />
                            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
                            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
                            <RowStyle BackColor="#E3EAEB" />
                            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
                            <SortedAscendingCellStyle BackColor="#F8FAFA" />
                            <SortedAscendingHeaderStyle BackColor="#246B61" />
                            <SortedDescendingCellStyle BackColor="#D4DFE1" />
                            <SortedDescendingHeaderStyle BackColor="#15524A" />
                        </asp:GridView>

                        <br />
                        <strong>
                            <asp:Label ID="Label3" runat="server" Text="Tổng doanh thu trong tháng :" 
                            style="font-size: large; font-weight: 700;"></asp:Label>&nbsp;
                            <br />
                            <asp:Label ID="Label4" runat="server" Text="Tháng :" 
                            style="font-size: large; font-weight: 700;"></asp:Label>&nbsp;
                            <asp:DropDownList ID="months" runat="server">
                                <asp:ListItem Value="1">THÁNG 1</asp:ListItem>
                                <asp:ListItem Value="2">THÁNG 2</asp:ListItem>
                                <asp:ListItem Value="3">THÁNG 3</asp:ListItem>
                                <asp:ListItem Value="4">THÁNG 4</asp:ListItem>
                                <asp:ListItem Value="5">THÁNG 5</asp:ListItem>
                                <asp:ListItem Value="6">THÁNG 6</asp:ListItem>
                                <asp:ListItem Value="7">THÁNG 7</asp:ListItem>
                                <asp:ListItem Value="8">THÁNG 8</asp:ListItem>
                                <asp:ListItem Value="9">THÁNG 9</asp:ListItem>
                                <asp:ListItem Value="10">THÁNG 10</asp:ListItem>
                                <asp:ListItem Value="11">THÁNG 11</asp:ListItem>
                                <asp:ListItem Value="12">THÁNG 12</asp:ListItem>
                            </asp:DropDownList>&nbsp;&nbsp;&nbsp;
                            
                            <asp:Label ID="Label5" runat="server" Text="Năm :" 
                            style="font-size: large; font-weight: 700;"></asp:Label>&nbsp;
                            <asp:DropDownList ID="DropDownListYear" runat="server" DataSourceID="Years" 
                            DataTextField="YEARS" DataValueField="YEARS">
                            </asp:DropDownList>
                            
                            &nbsp;&nbsp;&nbsp;
                            <asp:Button ID="Button1" runat="server" Text="XEM" 
                            onclick="Button1_Click" />

                            <asp:SqlDataSource ID="Years" runat="server" 
                                ConnectionString="<%$ ConnectionStrings:NHOMMUAConnectionString %>" 
                                SelectCommand="SELECT DISTINCT YEAR(TIME) AS YEARS FROM ORDERS">
                            </asp:SqlDataSource>
                        </strong>

                        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" 
                            CellPadding="4" ForeColor="#333333" GridLines="None">
                            <AlternatingRowStyle BackColor="White" />
                            <Columns>
                                <asp:BoundField DataField="SO_NGUOI_MUA" HeaderText="Số người mua" />
                                <asp:BoundField DataField="DOANHTHU" HeaderText="Doanh thu" />
                            </Columns>
                            <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                            <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                            <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                            <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                            <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
                            <SortedAscendingCellStyle BackColor="#FDF5AC" />
                            <SortedAscendingHeaderStyle BackColor="#4D0000" />
                            <SortedDescendingCellStyle BackColor="#FCF6C0" />
                            <SortedDescendingHeaderStyle BackColor="#820000" />
                        </asp:GridView>
                
                    </div>        
               
            </div>
            <div class="tail">
                
            </div>
        </div>
        
    </div>
</asp:Content>
